<?php
/**
 * Prado Portal.
 *
 * @author Steen Rabol <steen.rabol@gmail.com>
 * @link http://www.pradoportal.dk/
 * @copyright Copyright &copy; 2006,2007,2008 Steen Rabol
 * @license http://www.pradoportal.dk
 * @version $Id: MySQL.php 289 2008-11-14 05:34:40Z steen.rabol@gmail.com $
 *
 */

$drop_table[] = "DROP TABLE IF EXISTS tbldownloadfiles";
$create_table[] = "CREATE TABLE tbldownloadfiles (
  id int(10) unsigned NOT NULL auto_increment,
  grpid int(10) unsigned NOT NULL default '0',
  filename varchar(45) NOT NULL default '',
  active int(10) unsigned NOT NULL default '0',
  comment text NOT NULL,
  description varchar(45) NOT NULL default '',
  dlcount int(10) unsigned NOT NULL default '0',
  filesize int(10) unsigned NOT NULL default '0',
  filedate int(10) unsigned NOT NULL default '0',
  PRIMARY KEY (id)
)";

$drop_table[] = "DROP TABLE IF EXISTS tbldownloadportletgrps";
$create_table[] = "CREATE TABLE tbldownloadportletgrps (
  id int(10) unsigned NOT NULL auto_increment,
  name varchar(45) NOT NULL default '',
  description text NOT NULL,
  role int(10) unsigned NOT NULL default '0',
  active int(10) unsigned NOT NULL default '1',
  PRIMARY KEY (id)
)";
?>